Dataset info
| Number of variables | 50 |
|---|---|
| Number of observations | 101766 |
| Missing cells | 0 (0.0%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 225.2 MiB |
| Average record size in memory | 2.3 KiB |
Variables types
| CAT | 36 |
|---|---|
| NUM | 13 |
| BOOL | 1 |
Reproduction info
| Date of analysis | 2020-03-22 22:36:21.687814 |
|---|---|
| Version | pandas-profiling v2.4.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download Configuration | config.yaml |
Warnings
citoglipton has constant value "No" | Rejected |
diag_1 has a high cardinality: 717 distinct values | Warning |
diag_2 has a high cardinality: 749 distinct values | Warning |
diag_3 has a high cardinality: 790 distinct values | Warning |
examide has constant value "No" | Rejected |
medical_specialty has a high cardinality: 73 distinct values | Warning |
num_procedures has 46652 (45.8%) zeros | Zeros |
number_emergency is highly skewed (γ1 = 22.85558215) | Skewed |
number_emergency has 90383 (88.8%) zeros | Zeros |
number_inpatient has 67630 (66.5%) zeros | Zeros |
number_outpatient has 85027 (83.6%) zeros | Zeros |
examide is highly correlated with citoglipton | High Correlation |
citoglipton is highly correlated with examide | High Correlation |
A1Cresult
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| None | |
|---|---|
| >8 | 8216 |
| Norm | 4990 |
| >7 | 3812 |
| Value | Count | Frequency (%) | |
| None | 84748 | 83.3% | |
| >8 | 8216 | 8.1% | |
| Norm | 4990 | 4.9% | |
| >7 | 3812 | 3.7% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.763614567 |
| Min length | 2 |
acarbose
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| No | |
|---|---|
| Steady | 295 |
| Up | 10 |
| Down | 3 |
| Value | Count | Frequency (%) | |
| No | 101458 | 99.7% | |
| Steady | 295 | 0.3% | |
| Up | 10 | < 0.1% | |
| Down | 3 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 2.011654187 |
| Min length | 2 |
acetohexamide
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| No | |
|---|---|
| Steady | 1 |
| Value | Count | Frequency (%) | |
| No | 101765 | > 99.9% | |
| Steady | 1 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 2.000039306 |
| Min length | 2 |
admission_source_id
Real number (ℝ≥0)
| Distinct count | 17 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.754436649 |
|---|---|
| Minimum | 1 |
| Maximum | 25 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 795.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 7 |
| Q3 | 7 |
| 95-th percentile | 17 |
| Maximum | 25 |
| Range | 24 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 4.064080834 |
|---|---|
| Coefficient of variation (CV) | 0.7062517293 |
| Kurtosis | 1.744989372 |
| Mean | 5.754436649 |
| Median Absolute Deviation (MAD) | 2.976658809 |
| Skewness | 1.029934878 |
| Sum | 585606 |
| Variance | 16.51675303 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 4.5 ... 10.5 15.5 18.5 21. 25. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 7 | 57494 | 56.5% | |
| 1 | 29565 | 29.1% | |
| 17 | 6781 | 6.7% | |
| 4 | 3187 | 3.1% | |
| 6 | 2264 | 2.2% | |
| 2 | 1104 | 1.1% | |
| 5 | 855 | 0.8% | |
| 3 | 187 | 0.2% | |
| 20 | 161 | 0.2% | |
| 9 | 125 | 0.1% | |
| Other values (7) | 43 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 29565 | 29.1% | |
| 2 | 1104 | 1.1% | |
| 3 | 187 | 0.2% | |
| 4 | 3187 | 3.1% | |
| 5 | 855 | 0.8% |
| Value | Count | Frequency (%) | |
| 25 | 2 | < 0.1% | |
| 22 | 12 | < 0.1% | |
| 20 | 161 | 0.2% | |
| 17 | 6781 | 6.7% | |
| 14 | 2 | < 0.1% |
admission_type_id
Real number (ℝ≥0)
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.024006053 |
|---|---|
| Minimum | 1 |
| Maximum | 8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 795.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 3 |
| 95-th percentile | 6 |
| Maximum | 8 |
| Range | 7 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.44540283 |
|---|---|
| Coefficient of variation (CV) | 0.7141296972 |
| Kurtosis | 1.942476114 |
| Mean | 2.024006053 |
| Median Absolute Deviation (MAD) | 1.095252219 |
| Skewness | 1.591984327 |
| Sum | 205975 |
| Variance | 2.08918934 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[1. 1.5 3.5 4.5 5.5 6.5 7.5 8. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 1 | 53990 | 53.1% | |
| 3 | 18869 | 18.5% | |
| 2 | 18480 | 18.2% | |
| 6 | 5291 | 5.2% | |
| 5 | 4785 | 4.7% | |
| 8 | 320 | 0.3% | |
| 7 | 21 | < 0.1% | |
| 4 | 10 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 53990 | 53.1% | |
| 2 | 18480 | 18.2% | |
| 3 | 18869 | 18.5% | |
| 4 | 10 | < 0.1% | |
| 5 | 4785 | 4.7% |
| Value | Count | Frequency (%) | |
| 8 | 320 | 0.3% | |
| 7 | 21 | < 0.1% | |
| 6 | 5291 | 5.2% | |
| 5 | 4785 | 4.7% | |
| 4 | 10 | < 0.1% |
age
Categorical
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| [70-80) | |
|---|---|
| [60-70) | |
| [50-60) | |
| [80-90) | |
| [40-50) | |
| Other values (5) |
| Value | Count | Frequency (%) | |
| [70-80) | 26068 | 25.6% | |
| [60-70) | 22483 | 22.1% | |
| [50-60) | 17256 | 17.0% | |
| [80-90) | 17197 | 16.9% | |
| [40-50) | 9685 | 9.5% | |
| [30-40) | 3775 | 3.7% | |
| [90-100) | 2793 | 2.7% | |
| [20-30) | 1657 | 1.6% | |
| [10-20) | 691 | 0.7% | |
| [0-10) | 161 | 0.2% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 8 |
|---|---|
| Mean length | 7.025863255 |
| Min length | 6 |
change
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| No | |
|---|---|
| Ch |
| Value | Count | Frequency (%) | |
| No | 54755 | 53.8% | |
| Ch | 47011 | 46.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
chlorpropamide
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| No | |
|---|---|
| Steady | 79 |
| Up | 6 |
| Down | 1 |
| Value | Count | Frequency (%) | |
| No | 101680 | 99.9% | |
| Steady | 79 | 0.1% | |
| Up | 6 | < 0.1% | |
| Down | 1 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 2.003124816 |
| Min length | 2 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| No |
|---|
| Value | Count | Frequency (%) | |
| No | 101766 | 100.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
diabetesMed
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| Yes | |
|---|---|
| No |
| Value | Count | Frequency (%) | |
| Yes | 78363 | 77.0% | |
| No | 23403 | 23.0% |
| Distinct count | 717 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| 428 | 6862 |
|---|---|
| 414 | 6581 |
| 786 | 4016 |
| 410 | 3614 |
| 486 | 3508 |
| Other values (712) |
| Value | Count | Frequency (%) | |
| 428 | 6862 | 6.7% | |
| 414 | 6581 | 6.5% | |
| 786 | 4016 | 3.9% | |
| 410 | 3614 | 3.6% | |
| 486 | 3508 | 3.4% | |
| 427 | 2766 | 2.7% | |
| 491 | 2275 | 2.2% | |
| 715 | 2151 | 2.1% | |
| 682 | 2042 | 2.0% | |
| 434 | 2028 | 2.0% | |
| Other values (707) | 65923 | 64.8% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 6 |
|---|---|
| Mean length | 3.175215691 |
| Min length | 1 |
| Distinct count | 749 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| 276 | 6752 |
|---|---|
| 428 | 6662 |
| 250 | 6071 |
| 427 | 5036 |
| 401 | 3736 |
| Other values (744) |
| Value | Count | Frequency (%) | |
| 276 | 6752 | 6.6% | |
| 428 | 6662 | 6.5% | |
| 250 | 6071 | 6.0% | |
| 427 | 5036 | 4.9% | |
| 401 | 3736 | 3.7% | |
| 496 | 3305 | 3.2% | |
| 599 | 3288 | 3.2% | |
| 403 | 2823 | 2.8% | |
| 414 | 2650 | 2.6% | |
| 411 | 2566 | 2.5% | |
| Other values (739) | 58877 | 57.9% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 6 |
|---|---|
| Mean length | 3.166194996 |
| Min length | 1 |
| Distinct count | 790 |
|---|---|
| Unique (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| 250 | 11555 |
|---|---|
| 401 | 8289 |
| 276 | 5175 |
| 428 | 4577 |
| 427 | 3955 |
| Other values (785) |
| Value | Count | Frequency (%) | |
| 250 | 11555 | 11.4% | |
| 401 | 8289 | 8.1% | |
| 276 | 5175 | 5.1% | |
| 428 | 4577 | 4.5% | |
| 427 | 3955 | 3.9% | |
| 414 | 3664 | 3.6% | |
| 496 | 2605 | 2.6% | |
| 403 | 2357 | 2.3% | |
| 585 | 1992 | 2.0% | |
| 272 | 1969 | 1.9% | |
| Other values (780) | 55628 | 54.7% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 6 |
|---|---|
| Mean length | 3.111658118 |
| Min length | 1 |
discharge_disposition_id
Real number (ℝ≥0)
| Distinct count | 26 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.715641766 |
|---|---|
| Minimum | 1 |
| Maximum | 28 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 795.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 4 |
| 95-th percentile | 18 |
| Maximum | 28 |
| Range | 27 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 5.280165509 |
|---|---|
| Coefficient of variation (CV) | 1.421064204 |
| Kurtosis | 6.003346764 |
| Mean | 3.715641766 |
| Median Absolute Deviation (MAD) | 3.482713618 |
| Skewness | 2.563066993 |
| Sum | 378126 |
| Variance | 27.88014781 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 4.5 ... 23.5 24.5 26. 27.5 28. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 1 | 60234 | 59.2% | |
| 3 | 13954 | 13.7% | |
| 6 | 12902 | 12.7% | |
| 18 | 3691 | 3.6% | |
| 2 | 2128 | 2.1% | |
| 22 | 1993 | 2.0% | |
| 11 | 1642 | 1.6% | |
| 5 | 1184 | 1.2% | |
| 25 | 989 | 1.0% | |
| 4 | 815 | 0.8% | |
| Other values (16) | 2234 | 2.2% |
| Value | Count | Frequency (%) | |
| 1 | 60234 | 59.2% | |
| 2 | 2128 | 2.1% | |
| 3 | 13954 | 13.7% | |
| 4 | 815 | 0.8% | |
| 5 | 1184 | 1.2% |
| Value | Count | Frequency (%) | |
| 28 | 139 | 0.1% | |
| 27 | 5 | < 0.1% | |
| 25 | 989 | 1.0% | |
| 24 | 48 | < 0.1% | |
| 23 | 412 | 0.4% |
| Distinct count | 101766 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 165201645.6 |
|---|---|
| Minimum | 12522 |
| Maximum | 443867222 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 795.2 KiB |
Quantile statistics
| Minimum | 12522 |
|---|---|
| 5-th percentile | 27170784 |
| Q1 | 84961194 |
| median | 152388987 |
| Q3 | 230270887.5 |
| 95-th percentile | 378962843 |
| Maximum | 443867222 |
| Range | 443854700 |
| Interquartile range (IQR) | 145309693.5 |
Descriptive statistics
| Standard deviation | 102640296 |
|---|---|
| Coefficient of variation (CV) | 0.6213031087 |
| Kurtosis | -0.1020713932 |
| Mean | 165201645.6 |
| Median Absolute Deviation (MAD) | 81937223.14 |
| Skewness | 0.6991415513 |
| Sum | 1.681191067e+13 |
| Variance | 1.053503036e+16 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[1.25220000e+04 1.27266300e+06 2.26376100e+06 5.26507800e+06 5.29694400e+06 ... 4.42687751e+08 4.43106659e+08 4.43274728e+08 4.43695112e+08 4.43867222e+08], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 96210942 | 1 | < 0.1% | |
| 89943846 | 1 | < 0.1% | |
| 384306986 | 1 | < 0.1% | |
| 94650156 | 1 | < 0.1% | |
| 83156784 | 1 | < 0.1% | |
| 2674482 | 1 | < 0.1% | |
| 281345844 | 1 | < 0.1% | |
| 193616274 | 1 | < 0.1% | |
| 355508024 | 1 | < 0.1% | |
| 165973818 | 1 | < 0.1% | |
| Other values (101756) | 101756 | > 99.9% |
| Value | Count | Frequency (%) | |
| 12522 | 1 | < 0.1% | |
| 15738 | 1 | < 0.1% | |
| 16680 | 1 | < 0.1% | |
| 28236 | 1 | < 0.1% | |
| 35754 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 443867222 | 1 | < 0.1% | |
| 443857166 | 1 | < 0.1% | |
| 443854148 | 1 | < 0.1% | |
| 443847782 | 1 | < 0.1% | |
| 443847548 | 1 | < 0.1% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| No |
|---|
| Value | Count | Frequency (%) | |
| No | 101766 | 100.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
gender
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| Female | |
|---|---|
| Male | |
| Unknown/Invalid | 3 |
| Value | Count | Frequency (%) | |
| Female | 54708 | 53.8% | |
| Male | 47055 | 46.2% | |
| Unknown/Invalid | 3 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 15 |
|---|---|
| Mean length | 5.075496728 |
| Min length | 4 |
glimepiride
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| No | |
|---|---|
| Steady | 4670 |
| Up | 327 |
| Down | 194 |
| Value | Count | Frequency (%) | |
| No | 96575 | 94.9% | |
| Steady | 4670 | 4.6% | |
| Up | 327 | 0.3% | |
| Down | 194 | 0.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 2.187371028 |
| Min length | 2 |
glimepiride-pioglitazone
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| No | |
|---|---|
| Steady | 1 |
| Value | Count | Frequency (%) | |
| No | 101765 | > 99.9% | |
| Steady | 1 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 2.000039306 |
| Min length | 2 |
glipizide
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| No | |
|---|---|
| Steady | 11356 |
| Up | 770 |
| Down | 560 |
| Value | Count | Frequency (%) | |
| No | 89080 | 87.5% | |
| Steady | 11356 | 11.2% | |
| Up | 770 | 0.8% | |
| Down | 560 | 0.6% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 2.45736297 |
| Min length | 2 |
glipizide-metformin
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| No | |
|---|---|
| Steady | 13 |
| Value | Count | Frequency (%) | |
| No | 101753 | > 99.9% | |
| Steady | 13 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 2.000510976 |
| Min length | 2 |
glyburide
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| No | |
|---|---|
| Steady | 9274 |
| Up | 812 |
| Down | 564 |
| Value | Count | Frequency (%) | |
| No | 91116 | 89.5% | |
| Steady | 9274 | 9.1% | |
| Up | 812 | 0.8% | |
| Down | 564 | 0.6% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 2.375606784 |
| Min length | 2 |
glyburide-metformin
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| No | |
|---|---|
| Steady | 692 |
| Up | 8 |
| Down | 6 |
| Value | Count | Frequency (%) | |
| No | 101060 | 99.3% | |
| Steady | 692 | 0.7% | |
| Up | 8 | < 0.1% | |
| Down | 6 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 2.027317572 |
| Min length | 2 |
insulin
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| No | |
|---|---|
| Steady | |
| Down | |
| Up |
| Value | Count | Frequency (%) | |
| No | 47383 | 46.6% | |
| Steady | 30849 | 30.3% | |
| Down | 12218 | 12.0% | |
| Up | 11316 | 11.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 3.45266592 |
| Min length | 2 |
max_glu_serum
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| None | |
|---|---|
| Norm | 2597 |
| >200 | 1485 |
| >300 | 1264 |
| Value | Count | Frequency (%) | |
| None | 96420 | 94.7% | |
| Norm | 2597 | 2.6% | |
| >200 | 1485 | 1.5% | |
| >300 | 1264 | 1.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 4 |
|---|---|
| Mean length | 4 |
| Min length | 4 |
| Distinct count | 73 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| ? | |
|---|---|
| InternalMedicine | |
| Emergency/Trauma | 7565 |
| Family/GeneralPractice | 7440 |
| Cardiology | 5352 |
| Other values (68) |
| Value | Count | Frequency (%) | |
| ? | 49949 | 49.1% | |
| InternalMedicine | 14635 | 14.4% | |
| Emergency/Trauma | 7565 | 7.4% | |
| Family/GeneralPractice | 7440 | 7.3% | |
| Cardiology | 5352 | 5.3% | |
| Surgery-General | 3099 | 3.0% | |
| Nephrology | 1613 | 1.6% | |
| Orthopedics | 1400 | 1.4% | |
| Orthopedics-Reconstructive | 1233 | 1.2% | |
| Radiologist | 1140 | 1.1% | |
| Other values (63) | 8340 | 8.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 36 |
|---|---|
| Mean length | 8.612670243 |
| Min length | 1 |
metformin
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| No | |
|---|---|
| Steady | |
| Up | 1067 |
| Down | 575 |
| Value | Count | Frequency (%) | |
| No | 81778 | 80.4% | |
| Steady | 18346 | 18.0% | |
| Up | 1067 | 1.0% | |
| Down | 575 | 0.6% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 2.732405715 |
| Min length | 2 |
metformin-pioglitazone
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| No | |
|---|---|
| Steady | 1 |
| Value | Count | Frequency (%) | |
| No | 101765 | > 99.9% | |
| Steady | 1 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 2.000039306 |
| Min length | 2 |
metformin-rosiglitazone
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| No | |
|---|---|
| Steady | 2 |
| Value | Count | Frequency (%) | |
| No | 101764 | > 99.9% | |
| Steady | 2 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 2.000078612 |
| Min length | 2 |
miglitol
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| No | |
|---|---|
| Steady | 31 |
| Down | 5 |
| Up | 2 |
| Value | Count | Frequency (%) | |
| No | 101728 | > 99.9% | |
| Steady | 31 | < 0.1% | |
| Down | 5 | < 0.1% | |
| Up | 2 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 2.001316746 |
| Min length | 2 |
nateglinide
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| No | |
|---|---|
| Steady | 668 |
| Up | 24 |
| Down | 11 |
| Value | Count | Frequency (%) | |
| No | 101063 | 99.3% | |
| Steady | 668 | 0.7% | |
| Up | 24 | < 0.1% | |
| Down | 11 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 2.026472496 |
| Min length | 2 |
num_lab_procedures
Real number (ℝ≥0)
| Distinct count | 118 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 43.09564098 |
|---|---|
| Minimum | 1 |
| Maximum | 132 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 795.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 31 |
| median | 44 |
| Q3 | 57 |
| 95-th percentile | 73 |
| Maximum | 132 |
| Range | 131 |
| Interquartile range (IQR) | 26 |
Descriptive statistics
| Standard deviation | 19.67436225 |
|---|---|
| Coefficient of variation (CV) | 0.4565278947 |
| Kurtosis | -0.2450735189 |
| Mean | 43.09564098 |
| Median Absolute Deviation (MAD) | 15.57390322 |
| Skewness | -0.2365439206 |
| Sum | 4385671 |
| Variance | 387.0805299 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 4.5 ... 95.5 98.5 103.5 113.5 132. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 1 | 3208 | 3.2% | |
| 43 | 2804 | 2.8% | |
| 44 | 2496 | 2.5% | |
| 45 | 2376 | 2.3% | |
| 38 | 2213 | 2.2% | |
| 40 | 2201 | 2.2% | |
| 46 | 2189 | 2.2% | |
| 41 | 2117 | 2.1% | |
| 42 | 2113 | 2.1% | |
| 47 | 2106 | 2.1% | |
| Other values (108) | 77943 | 76.6% |
| Value | Count | Frequency (%) | |
| 1 | 3208 | 3.2% | |
| 2 | 1101 | 1.1% | |
| 3 | 668 | 0.7% | |
| 4 | 378 | 0.4% | |
| 5 | 286 | 0.3% |
| Value | Count | Frequency (%) | |
| 132 | 1 | < 0.1% | |
| 129 | 1 | < 0.1% | |
| 126 | 1 | < 0.1% | |
| 121 | 1 | < 0.1% | |
| 120 | 1 | < 0.1% |
num_medications
Real number (ℝ≥0)
| Distinct count | 75 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.02184423 |
|---|---|
| Minimum | 1 |
| Maximum | 81 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 795.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 10 |
| median | 15 |
| Q3 | 20 |
| 95-th percentile | 31 |
| Maximum | 81 |
| Range | 80 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 8.127566209 |
|---|---|
| Coefficient of variation (CV) | 0.5072803163 |
| Kurtosis | 3.468154915 |
| Mean | 16.02184423 |
| Median Absolute Deviation (MAD) | 6.108492005 |
| Skewness | 1.326672134 |
| Sum | 1630479 |
| Variance | 66.05733248 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 1. 2.5 3.5 4.5 5.5 ... 52.5 58.5 63.5 69.5 81. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 13 | 6086 | 6.0% | |
| 12 | 6004 | 5.9% | |
| 11 | 5795 | 5.7% | |
| 15 | 5792 | 5.7% | |
| 14 | 5707 | 5.6% | |
| 16 | 5430 | 5.3% | |
| 10 | 5346 | 5.3% | |
| 17 | 4919 | 4.8% | |
| 9 | 4913 | 4.8% | |
| 18 | 4523 | 4.4% | |
| Other values (65) | 47251 | 46.4% |
| Value | Count | Frequency (%) | |
| 1 | 262 | 0.3% | |
| 2 | 470 | 0.5% | |
| 3 | 900 | 0.9% | |
| 4 | 1417 | 1.4% | |
| 5 | 2017 | 2.0% |
| Value | Count | Frequency (%) | |
| 81 | 1 | < 0.1% | |
| 79 | 1 | < 0.1% | |
| 75 | 2 | < 0.1% | |
| 74 | 1 | < 0.1% | |
| 72 | 3 | < 0.1% |
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.339730362 |
|---|---|
| Minimum | 0 |
| Maximum | 6 |
| Zeros | 46652 |
| Zeros (%) | 45.8% |
| Memory size | 795.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 5 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.705806979 |
|---|---|
| Coefficient of variation (CV) | 1.273246489 |
| Kurtosis | 0.8571103021 |
| Mean | 1.339730362 |
| Median Absolute Deviation (MAD) | 1.366817758 |
| Skewness | 1.316414763 |
| Sum | 136339 |
| Variance | 2.90977745 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 46652 | 45.8% | |
| 1 | 20742 | 20.4% | |
| 2 | 12717 | 12.5% | |
| 3 | 9443 | 9.3% | |
| 6 | 4954 | 4.9% | |
| 4 | 4180 | 4.1% | |
| 5 | 3078 | 3.0% |
| Value | Count | Frequency (%) | |
| 0 | 46652 | 45.8% | |
| 1 | 20742 | 20.4% | |
| 2 | 12717 | 12.5% | |
| 3 | 9443 | 9.3% | |
| 4 | 4180 | 4.1% |
| Value | Count | Frequency (%) | |
| 6 | 4954 | 4.9% | |
| 5 | 3078 | 3.0% | |
| 4 | 4180 | 4.1% | |
| 3 | 9443 | 9.3% | |
| 2 | 12717 | 12.5% |
number_diagnoses
Real number (ℝ≥0)
| Distinct count | 16 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.422606765 |
|---|---|
| Minimum | 1 |
| Maximum | 16 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 795.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 6 |
| median | 8 |
| Q3 | 9 |
| 95-th percentile | 9 |
| Maximum | 16 |
| Range | 15 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.933600145 |
|---|---|
| Coefficient of variation (CV) | 0.2605014931 |
| Kurtosis | -0.07905602427 |
| Mean | 7.422606765 |
| Median Absolute Deviation (MAD) | 1.668356027 |
| Skewness | -0.8767462388 |
| Sum | 755369 |
| Variance | 3.738809521 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 4.5 5.5 8.5 9.5 15.5 16. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 9 | 49474 | 48.6% | |
| 5 | 11393 | 11.2% | |
| 8 | 10616 | 10.4% | |
| 7 | 10393 | 10.2% | |
| 6 | 10161 | 10.0% | |
| 4 | 5537 | 5.4% | |
| 3 | 2835 | 2.8% | |
| 2 | 1023 | 1.0% | |
| 1 | 219 | 0.2% | |
| 16 | 45 | < 0.1% | |
| Other values (6) | 70 | 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 219 | 0.2% | |
| 2 | 1023 | 1.0% | |
| 3 | 2835 | 2.8% | |
| 4 | 5537 | 5.4% | |
| 5 | 11393 | 11.2% |
| Value | Count | Frequency (%) | |
| 16 | 45 | < 0.1% | |
| 15 | 10 | < 0.1% | |
| 14 | 7 | < 0.1% | |
| 13 | 16 | < 0.1% | |
| 12 | 9 | < 0.1% |
| Distinct count | 33 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1978362125 |
|---|---|
| Minimum | 0 |
| Maximum | 76 |
| Zeros | 90383 |
| Zeros (%) | 88.8% |
| Memory size | 795.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 76 |
| Range | 76 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.9304722684 |
|---|---|
| Coefficient of variation (CV) | 4.703245461 |
| Kurtosis | 1191.686726 |
| Mean | 0.1978362125 |
| Median Absolute Deviation (MAD) | 0.3514146256 |
| Skewness | 22.85558215 |
| Sum | 20133 |
| Variance | 0.8657786423 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 7.5 11.5 13.5 23. 76. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 90383 | 88.8% | |
| 1 | 7677 | 7.5% | |
| 2 | 2042 | 2.0% | |
| 3 | 725 | 0.7% | |
| 4 | 374 | 0.4% | |
| 5 | 192 | 0.2% | |
| 6 | 94 | 0.1% | |
| 7 | 73 | 0.1% | |
| 8 | 50 | < 0.1% | |
| 10 | 34 | < 0.1% | |
| Other values (23) | 122 | 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 90383 | 88.8% | |
| 1 | 7677 | 7.5% | |
| 2 | 2042 | 2.0% | |
| 3 | 725 | 0.7% | |
| 4 | 374 | 0.4% |
| Value | Count | Frequency (%) | |
| 76 | 1 | < 0.1% | |
| 64 | 1 | < 0.1% | |
| 63 | 1 | < 0.1% | |
| 54 | 1 | < 0.1% | |
| 46 | 1 | < 0.1% |
| Distinct count | 21 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6355659061 |
|---|---|
| Minimum | 0 |
| Maximum | 21 |
| Zeros | 67630 |
| Zeros (%) | 66.5% |
| Memory size | 795.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 21 |
| Range | 21 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.26286329 |
|---|---|
| Coefficient of variation (CV) | 1.986990299 |
| Kurtosis | 20.71939695 |
| Mean | 0.6355659061 |
| Median Absolute Deviation (MAD) | 0.8447481915 |
| Skewness | 3.614138992 |
| Sum | 64679 |
| Variance | 1.594823689 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 9.5 11.5 13.5 16.5 21. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 67630 | 66.5% | |
| 1 | 19521 | 19.2% | |
| 2 | 7566 | 7.4% | |
| 3 | 3411 | 3.4% | |
| 4 | 1622 | 1.6% | |
| 5 | 812 | 0.8% | |
| 6 | 480 | 0.5% | |
| 7 | 268 | 0.3% | |
| 8 | 151 | 0.1% | |
| 9 | 111 | 0.1% | |
| Other values (11) | 194 | 0.2% |
| Value | Count | Frequency (%) | |
| 0 | 67630 | 66.5% | |
| 1 | 19521 | 19.2% | |
| 2 | 7566 | 7.4% | |
| 3 | 3411 | 3.4% | |
| 4 | 1622 | 1.6% |
| Value | Count | Frequency (%) | |
| 21 | 1 | < 0.1% | |
| 19 | 2 | < 0.1% | |
| 18 | 1 | < 0.1% | |
| 17 | 1 | < 0.1% | |
| 16 | 6 | < 0.1% |
| Distinct count | 39 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.3693571527 |
|---|---|
| Minimum | 0 |
| Maximum | 42 |
| Zeros | 85027 |
| Zeros (%) | 83.6% |
| Memory size | 795.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 42 |
| Range | 42 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.267265097 |
|---|---|
| Coefficient of variation (CV) | 3.431001911 |
| Kurtosis | 147.9077363 |
| Mean | 0.3693571527 |
| Median Absolute Deviation (MAD) | 0.6172067414 |
| Skewness | 8.832958927 |
| Sum | 37588 |
| Variance | 1.605960825 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 9.5 11.5 16.5 22.5 42. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 85027 | 83.6% | |
| 1 | 8547 | 8.4% | |
| 2 | 3594 | 3.5% | |
| 3 | 2042 | 2.0% | |
| 4 | 1099 | 1.1% | |
| 5 | 533 | 0.5% | |
| 6 | 303 | 0.3% | |
| 7 | 155 | 0.2% | |
| 8 | 98 | 0.1% | |
| 9 | 83 | 0.1% | |
| Other values (29) | 285 | 0.3% |
| Value | Count | Frequency (%) | |
| 0 | 85027 | 83.6% | |
| 1 | 8547 | 8.4% | |
| 2 | 3594 | 3.5% | |
| 3 | 2042 | 2.0% | |
| 4 | 1099 | 1.1% |
| Value | Count | Frequency (%) | |
| 42 | 1 | < 0.1% | |
| 40 | 1 | < 0.1% | |
| 39 | 1 | < 0.1% | |
| 38 | 1 | < 0.1% | |
| 37 | 1 | < 0.1% |
patient_nbr
Real number (ℝ≥0)
| Distinct count | 71518 |
|---|---|
| Unique (%) | 70.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54330400.69 |
|---|---|
| Minimum | 135 |
| Maximum | 189502619 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 795.2 KiB |
Quantile statistics
| Minimum | 135 |
|---|---|
| 5-th percentile | 1456971.75 |
| Q1 | 23413221 |
| median | 45505143 |
| Q3 | 87545949.75 |
| 95-th percentile | 111480273 |
| Maximum | 189502619 |
| Range | 189502484 |
| Interquartile range (IQR) | 64132728.75 |
Descriptive statistics
| Standard deviation | 38696359.35 |
|---|---|
| Coefficient of variation (CV) | 0.7122413759 |
| Kurtosis | -0.3473720444 |
| Mean | 54330400.69 |
| Median Absolute Deviation (MAD) | 33216794.71 |
| Skewness | 0.4712807224 |
| Sum | 5.528987557e+12 |
| Variance | 1.497408227e+15 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[1.35000000e+02 1.30230000e+04 1.30815000e+04 1.03099500e+05 1.03167000e+05 ... 1.75829585e+08 1.80315072e+08 1.81693846e+08 1.84553753e+08 1.89502619e+08], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 88785891 | 40 | < 0.1% | |
| 43140906 | 28 | < 0.1% | |
| 23199021 | 23 | < 0.1% | |
| 1660293 | 23 | < 0.1% | |
| 88227540 | 23 | < 0.1% | |
| 23643405 | 22 | < 0.1% | |
| 84428613 | 22 | < 0.1% | |
| 92709351 | 21 | < 0.1% | |
| 23398488 | 20 | < 0.1% | |
| 90609804 | 20 | < 0.1% | |
| Other values (71508) | 101524 | 99.8% |
| Value | Count | Frequency (%) | |
| 135 | 2 | < 0.1% | |
| 378 | 1 | < 0.1% | |
| 729 | 1 | < 0.1% | |
| 774 | 1 | < 0.1% | |
| 927 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 189502619 | 1 | < 0.1% | |
| 189481478 | 1 | < 0.1% | |
| 189445127 | 1 | < 0.1% | |
| 189365864 | 1 | < 0.1% | |
| 189351095 | 1 | < 0.1% |
payer_code
Categorical
| Distinct count | 18 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| ? | |
|---|---|
| MC | |
| HM | 6274 |
| SP | 5007 |
| BC | 4655 |
| Other values (13) |
| Value | Count | Frequency (%) | |
| ? | 40256 | 39.6% | |
| MC | 32439 | 31.9% | |
| HM | 6274 | 6.2% | |
| SP | 5007 | 4.9% | |
| BC | 4655 | 4.6% | |
| MD | 3532 | 3.5% | |
| CP | 2533 | 2.5% | |
| UN | 2448 | 2.4% | |
| CM | 1937 | 1.9% | |
| OG | 1033 | 1.0% | |
| Other values (8) | 1652 | 1.6% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 2 |
|---|---|
| Mean length | 1.60442584 |
| Min length | 1 |
pioglitazone
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| No | |
|---|---|
| Steady | 6976 |
| Up | 234 |
| Down | 118 |
| Value | Count | Frequency (%) | |
| No | 94438 | 92.8% | |
| Steady | 6976 | 6.9% | |
| Up | 234 | 0.2% | |
| Down | 118 | 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 2.276516715 |
| Min length | 2 |
race
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| Caucasian | |
|---|---|
| AfricanAmerican | |
| ? | 2273 |
| Hispanic | 2037 |
| Other | 1506 |
| Value | Count | Frequency (%) | |
| Caucasian | 76099 | 74.8% | |
| AfricanAmerican | 19210 | 18.9% | |
| ? | 2273 | 2.2% | |
| Hispanic | 2037 | 2.0% | |
| Other | 1506 | 1.5% | |
| Asian | 641 | 0.6% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 15 |
|---|---|
| Mean length | 9.849507694 |
| Min length | 1 |
readmitted
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| NO | |
|---|---|
| >30 | |
| <30 |
| Value | Count | Frequency (%) | |
| NO | 54864 | 53.9% | |
| >30 | 35545 | 34.9% | |
| <30 | 11357 | 11.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 2.460880844 |
| Min length | 2 |
repaglinide
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| No | |
|---|---|
| Steady | 1384 |
| Up | 110 |
| Down | 45 |
| Value | Count | Frequency (%) | |
| No | 100227 | 98.5% | |
| Steady | 1384 | 1.4% | |
| Up | 110 | 0.1% | |
| Down | 45 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 2.05528369 |
| Min length | 2 |
rosiglitazone
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| No | |
|---|---|
| Steady | 6100 |
| Up | 178 |
| Down | 87 |
| Value | Count | Frequency (%) | |
| No | 95401 | 93.7% | |
| Steady | 6100 | 6.0% | |
| Up | 178 | 0.2% | |
| Down | 87 | 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 2.241475542 |
| Min length | 2 |
time_in_hospital
Real number (ℝ≥0)
| Distinct count | 14 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.395986872 |
|---|---|
| Minimum | 1 |
| Maximum | 14 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 795.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 11 |
| Maximum | 14 |
| Range | 13 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.985107767 |
|---|---|
| Coefficient of variation (CV) | 0.6790529304 |
| Kurtosis | 0.8502508405 |
| Mean | 4.395986872 |
| Median Absolute Deviation (MAD) | 2.35480462 |
| Skewness | 1.133998719 |
| Sum | 447362 |
| Variance | 8.910868383 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 3 | 17756 | 17.4% | |
| 2 | 17224 | 16.9% | |
| 1 | 14208 | 14.0% | |
| 4 | 13924 | 13.7% | |
| 5 | 9966 | 9.8% | |
| 6 | 7539 | 7.4% | |
| 7 | 5859 | 5.8% | |
| 8 | 4391 | 4.3% | |
| 9 | 3002 | 2.9% | |
| 10 | 2342 | 2.3% | |
| Other values (4) | 5555 | 5.5% |
| Value | Count | Frequency (%) | |
| 1 | 14208 | 14.0% | |
| 2 | 17224 | 16.9% | |
| 3 | 17756 | 17.4% | |
| 4 | 13924 | 13.7% | |
| 5 | 9966 | 9.8% |
| Value | Count | Frequency (%) | |
| 14 | 1042 | 1.0% | |
| 13 | 1210 | 1.2% | |
| 12 | 1448 | 1.4% | |
| 11 | 1855 | 1.8% | |
| 10 | 2342 | 2.3% |
tolazamide
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| No | |
|---|---|
| Steady | 38 |
| Up | 1 |
| Value | Count | Frequency (%) | |
| No | 101727 | > 99.9% | |
| Steady | 38 | < 0.1% | |
| Up | 1 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 2.001493623 |
| Min length | 2 |
tolbutamide
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| No | |
|---|---|
| Steady | 23 |
| Value | Count | Frequency (%) | |
| No | 101743 | > 99.9% | |
| Steady | 23 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 2.000904035 |
| Min length | 2 |
troglitazone
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| No | |
|---|---|
| Steady | 3 |
| Value | Count | Frequency (%) | |
| No | 101763 | > 99.9% | |
| Steady | 3 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 2.000117918 |
| Min length | 2 |
weight
Categorical
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 795.2 KiB |
| ? | |
|---|---|
| [75-100) | 1336 |
| [50-75) | 897 |
| [100-125) | 625 |
| [125-150) | 145 |
| Other values (5) | 194 |
| Value | Count | Frequency (%) | |
| ? | 98569 | 96.9% | |
| [75-100) | 1336 | 1.3% | |
| [50-75) | 897 | 0.9% | |
| [100-125) | 625 | 0.6% | |
| [125-150) | 145 | 0.1% | |
| [25-50) | 97 | 0.1% | |
| [0-25) | 48 | < 0.1% | |
| [150-175) | 35 | < 0.1% | |
| [175-200) | 11 | < 0.1% | |
| >200 | 3 | < 0.1% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 9 |
|---|---|
| Mean length | 1.217096083 |
| Min length | 1 |
First rows
| A1Cresult | acarbose | acetohexamide | admission_source_id | admission_type_id | age | change | chlorpropamide | citoglipton | diabetesMed | diag_1 | diag_2 | diag_3 | discharge_disposition_id | encounter_id | examide | gender | glimepiride | glimepiride-pioglitazone | glipizide | glipizide-metformin | glyburide | glyburide-metformin | insulin | max_glu_serum | medical_specialty | metformin | metformin-pioglitazone | metformin-rosiglitazone | miglitol | nateglinide | num_lab_procedures | num_medications | num_procedures | number_diagnoses | number_emergency | number_inpatient | number_outpatient | patient_nbr | payer_code | pioglitazone | race | readmitted | repaglinide | rosiglitazone | time_in_hospital | tolazamide | tolbutamide | troglitazone | weight | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | None | No | No | 1 | 6 | [0-10) | No | No | No | No | 250.83 | ? | ? | 25 | 2278392 | No | Female | No | No | No | No | No | No | No | None | Pediatrics-Endocrinology | No | No | No | No | No | 41 | 1 | 0 | 1 | 0 | 0 | 0 | 8222157 | ? | No | Caucasian | NO | No | No | 1 | No | No | No | ? |
| 1 | None | No | No | 7 | 1 | [10-20) | Ch | No | No | Yes | 276 | 250.01 | 255 | 1 | 149190 | No | Female | No | No | No | No | No | No | Up | None | ? | No | No | No | No | No | 59 | 18 | 0 | 9 | 0 | 0 | 0 | 55629189 | ? | No | Caucasian | >30 | No | No | 3 | No | No | No | ? |
| 2 | None | No | No | 7 | 1 | [20-30) | No | No | No | Yes | 648 | 250 | V27 | 1 | 64410 | No | Female | No | No | Steady | No | No | No | No | None | ? | No | No | No | No | No | 11 | 13 | 5 | 6 | 0 | 1 | 2 | 86047875 | ? | No | AfricanAmerican | NO | No | No | 2 | No | No | No | ? |
| 3 | None | No | No | 7 | 1 | [30-40) | Ch | No | No | Yes | 8 | 250.43 | 403 | 1 | 500364 | No | Male | No | No | No | No | No | No | Up | None | ? | No | No | No | No | No | 44 | 16 | 1 | 7 | 0 | 0 | 0 | 82442376 | ? | No | Caucasian | NO | No | No | 2 | No | No | No | ? |
| 4 | None | No | No | 7 | 1 | [40-50) | Ch | No | No | Yes | 197 | 157 | 250 | 1 | 16680 | No | Male | No | No | Steady | No | No | No | Steady | None | ? | No | No | No | No | No | 51 | 8 | 0 | 5 | 0 | 0 | 0 | 42519267 | ? | No | Caucasian | NO | No | No | 1 | No | No | No | ? |
| 5 | None | No | No | 2 | 2 | [50-60) | No | No | No | Yes | 414 | 411 | 250 | 1 | 35754 | No | Male | No | No | No | No | No | No | Steady | None | ? | No | No | No | No | No | 31 | 16 | 6 | 9 | 0 | 0 | 0 | 82637451 | ? | No | Caucasian | >30 | No | No | 3 | No | No | No | ? |
| 6 | None | No | No | 2 | 3 | [60-70) | Ch | No | No | Yes | 414 | 411 | V45 | 1 | 55842 | No | Male | Steady | No | No | No | No | No | Steady | None | ? | Steady | No | No | No | No | 70 | 21 | 1 | 7 | 0 | 0 | 0 | 84259809 | ? | No | Caucasian | NO | No | No | 4 | No | No | No | ? |
| 7 | None | No | No | 7 | 1 | [70-80) | No | No | No | Yes | 428 | 492 | 250 | 1 | 63768 | No | Male | No | No | No | No | Steady | No | No | None | ? | No | No | No | No | No | 73 | 12 | 0 | 8 | 0 | 0 | 0 | 114882984 | ? | No | Caucasian | >30 | No | No | 5 | No | No | No | ? |
| 8 | None | No | No | 4 | 2 | [80-90) | Ch | No | No | Yes | 398 | 427 | 38 | 1 | 12522 | No | Female | No | No | Steady | No | No | No | Steady | None | ? | No | No | No | No | No | 68 | 28 | 2 | 8 | 0 | 0 | 0 | 48330783 | ? | No | Caucasian | NO | No | No | 13 | No | No | No | ? |
| 9 | None | No | No | 4 | 3 | [90-100) | Ch | No | No | Yes | 434 | 198 | 486 | 3 | 15738 | No | Female | No | No | No | No | No | No | Steady | None | InternalMedicine | No | No | No | No | No | 33 | 18 | 3 | 8 | 0 | 0 | 0 | 63555939 | ? | No | Caucasian | NO | No | Steady | 12 | No | No | No | ? |
Last rows
| A1Cresult | acarbose | acetohexamide | admission_source_id | admission_type_id | age | change | chlorpropamide | citoglipton | diabetesMed | diag_1 | diag_2 | diag_3 | discharge_disposition_id | encounter_id | examide | gender | glimepiride | glimepiride-pioglitazone | glipizide | glipizide-metformin | glyburide | glyburide-metformin | insulin | max_glu_serum | medical_specialty | metformin | metformin-pioglitazone | metformin-rosiglitazone | miglitol | nateglinide | num_lab_procedures | num_medications | num_procedures | number_diagnoses | number_emergency | number_inpatient | number_outpatient | patient_nbr | payer_code | pioglitazone | race | readmitted | repaglinide | rosiglitazone | time_in_hospital | tolazamide | tolbutamide | troglitazone | weight | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 101756 | None | No | No | 7 | 1 | [60-70) | No | No | No | Yes | 996 | 585 | 403 | 1 | 443842070 | No | Female | No | No | No | No | No | No | Steady | None | ? | No | No | No | No | No | 46 | 17 | 6 | 9 | 1 | 1 | 1 | 140199494 | MD | No | Other | >30 | No | No | 2 | No | No | No | ? |
| 101757 | None | No | No | 7 | 1 | [70-80) | No | No | No | Yes | 491 | 518 | 511 | 1 | 443842136 | No | Female | No | No | No | No | No | No | Steady | None | ? | No | No | No | No | No | 21 | 16 | 1 | 9 | 0 | 1 | 0 | 181593374 | ? | No | Caucasian | NO | No | No | 5 | No | No | No | ? |
| 101758 | None | No | No | 7 | 1 | [80-90) | Ch | No | No | Yes | 292 | 8 | 304 | 1 | 443842340 | No | Female | No | No | No | No | No | No | Up | None | ? | No | No | No | No | No | 76 | 22 | 1 | 9 | 1 | 0 | 0 | 120975314 | MC | No | Caucasian | NO | No | No | 5 | No | No | No | ? |
| 101759 | None | No | No | 7 | 1 | [80-90) | Ch | No | No | Yes | 435 | 784 | 250 | 1 | 443842778 | No | Male | No | No | No | No | No | No | Up | None | ? | No | No | No | No | No | 1 | 15 | 0 | 7 | 0 | 0 | 3 | 86472243 | MC | No | Caucasian | NO | No | No | 1 | No | No | No | ? |
| 101760 | None | No | No | 7 | 1 | [60-70) | Ch | No | No | Yes | 345 | 438 | 412 | 1 | 443847176 | No | Female | No | No | No | No | No | No | Down | None | ? | No | No | No | No | No | 45 | 25 | 1 | 9 | 1 | 2 | 3 | 50375628 | DM | No | AfricanAmerican | >30 | No | Steady | 6 | No | No | No | ? |
| 101761 | >8 | No | No | 7 | 1 | [70-80) | Ch | No | No | Yes | 250.13 | 291 | 458 | 3 | 443847548 | No | Male | No | No | No | No | No | No | Down | None | ? | Steady | No | No | No | No | 51 | 16 | 0 | 9 | 0 | 0 | 0 | 100162476 | MC | No | AfricanAmerican | >30 | No | No | 3 | No | No | No | ? |
| 101762 | None | No | No | 5 | 1 | [80-90) | No | No | No | Yes | 560 | 276 | 787 | 4 | 443847782 | No | Female | No | No | No | No | No | No | Steady | None | ? | No | No | No | No | No | 33 | 18 | 3 | 9 | 0 | 1 | 0 | 74694222 | MC | No | AfricanAmerican | NO | No | No | 5 | No | No | No | ? |
| 101763 | None | No | No | 7 | 1 | [70-80) | Ch | No | No | Yes | 38 | 590 | 296 | 1 | 443854148 | No | Male | No | No | No | No | No | No | Down | None | ? | Steady | No | No | No | No | 53 | 9 | 0 | 13 | 0 | 0 | 1 | 41088789 | MC | No | Caucasian | NO | No | No | 1 | No | No | No | ? |
| 101764 | None | No | No | 7 | 2 | [80-90) | Ch | No | No | Yes | 996 | 285 | 998 | 3 | 443857166 | No | Female | No | No | Steady | No | No | No | Up | None | Surgery-General | No | No | No | No | No | 45 | 21 | 2 | 9 | 0 | 1 | 0 | 31693671 | MC | Steady | Caucasian | NO | No | No | 10 | No | No | No | ? |
| 101765 | None | No | No | 7 | 1 | [70-80) | No | No | No | No | 530 | 530 | 787 | 1 | 443867222 | No | Male | No | No | No | No | No | No | No | None | ? | No | No | No | No | No | 13 | 3 | 3 | 9 | 0 | 0 | 0 | 175429310 | ? | No | Caucasian | NO | No | No | 6 | No | No | No | ? |